drop table if exists  jms_dwd.dwd_tms_trunk_oper_eff_dt ;
create external table  jms_dwd.dwd_tms_trunk_oper_eff_dt (
 shipment_no		   	 string		comment '任务编号'
,shipment_name	         string		comment '任务名称'
,setout_arrive_sitename	 string		comment '任务拆分名称'
,setout_sitename         string		comment '任务出发站点名称'
,setout_sitecode         string		comment '任务出发站点编码'
,arrive_sitename         string		comment '任务到达站点名称'
,arrive_sitecode         string		comment '任务到达站点名称'
,packagecode             string		comment '所属袋号'
,nextstation             string		comment '下一站点'
,billcode                string		comment '运单编号'
,arrive_scantime         timestamp 	comment '卸车扫描时间'
,setout_scantime         timestamp 	comment '装车扫描时间'
,operation_duration    	 double    	comment '操作时间'
,actual_arrival_time				date comment '实际到车时间'
)
    comment '干线操作时效明细表'
    partitioned by (
		dt         string comment '更新日期 (yyyy-mm-dd)')
    stored as parquet
    location '/dw/hive/jms_dwd.db/external/dwd_tms_trunk_oper_eff_dt'
    tblproperties (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );

msck repair table  jms_dwd.dwd_tms_trunk_oper_eff_dt;